<?php
namespace app\index\controller;
use PhpOffice\PhpSpreadsheet\Spreadsheet;
use PhpOffice\PhpSpreadsheet\Writer\Xlsx;

use think\Db;
class Index
{
    public function index()
    {
        return '<style type="text/css">*{ padding: 0; margin: 0; } .think_default_text{ padding: 4px 48px;} a{color:#2E5CD5;cursor: pointer;text-decoration: none} a:hover{text-decoration:underline; } body{ background: #fff; font-family: "Century Gothic","Microsoft yahei"; color: #333;font-size:18px} h1{ font-size: 100px; font-weight: normal; margin-bottom: 12px; } p{ line-height: 1.6em; font-size: 42px }</style><div style="padding: 24px 48px;"> <h1>:)</h1><p> ThinkPHP V5<br/><span style="font-size:30px">十年磨一剑 - 为API开发设计的高性能框架</span></p><span style="font-size:22px;">[ V5.0 版本由 <a href="http://www.qiniu.com" target="qiniu">七牛云</a> 独家赞助发布 ]</span></div><script type="text/javascript" src="https://tajs.qq.com/stats?sId=9347272" charset="UTF-8"></script><script type="text/javascript" src="https://e.topthink.com/Public/static/client.js"></script><think id="ad_bd568ce7058a1091"></think>';
    }



    public function test(){
        return 123;
    }
    public function excel(){
$order_list=db::name('order')->field('order_sn,goods_num,name,mobile,address')->select();

        $excel = new Office();
//导出内容
        $orders=$order_list;
//设置表头：
        $head = ['订单编号', '商品总数', '收货人', '联系电话', '收货地址'];

//数据中对应的字段，用于读取相应数据：
        $keys = ['order_sn', 'goods_num', 'name', 'mobile', 'address'];

        $excel->outdata('订单表', $orders, $head, $keys);


    }

    //发邮件测试
    public function send(){
        $sult=send_email('1302022133@qq.com','买的啥','好吃的');
        if($sult){
            var_dump($sult);
        }
    }



}
